package com.example.demo.Mappers;

import com.example.demo.beans.RegDoctListBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by Administrator on 2018/4/13.
 */
@Mapper
public interface GetRegDoctListMapper {
    @Select("select  DepName,DoctName,DoctID,RankName,convert(varchar,bcfabm)+convert(varchar,RegID)as RegID,TypeName,TypeID,convert(int,RegFee)RegFee,convert(int,TreatFee)TreatFee,OtherFee,TimeRegion ,Specialty,RegRemained  from AutoView_RegDoctList" +
            " where DeptID=#{DeptID} and DAY=#{DAY}")
    List<RegDoctListBean>getDocList(@Param("DeptID") String DeptID,@Param("DAY")String DAY);
}
